package com.dwxt.sport.dao;

import com.dwxt.sport.entity.Analysis;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;
import java.util.Map;

@org.apache.ibatis.annotations.Mapper
public interface AnalysisMapper extends Mapper<Analysis> {


    List<Analysis> selectAllSceneAnalysisByCategory(@Param("year") Integer year, @Param("month") Integer month,
                                                    @Param("category") String category);

    List<String> selectXArr(@Param("year") Integer year, @Param("month") Integer month, @Param("name") String[] name,
                            @Param("category") String category);

    Map selectLocationAnalysis(@Param("year") int year, @Param("month") int month);

    List<Map> selectCityAnalysis(@Param("year") int year, @Param("month") int month);

    List<Analysis> selectTopThreeAnalysis(@Param("year") Integer year, @Param("month") Integer month,
                                          @Param("sceneName") String sceneName);

    Map<String, String> selectAllGroupByName(@Param("year") Integer year, @Param("month") Integer month,
                                             @Param("name") String name,
                                             @Param("category") String category);

    List<Analysis> selectALLAreaTopThreeAnalysis(@Param("year") Integer year, @Param("month") Integer month,
                                                 @Param("sceneName") String sceneName);
}